﻿CREATE TABLE [dbo].[CallCenter_Record_Sum] (
    [id]         INT           IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL,
    [CompanyId]  INT           NULL,
    [DeptId]     INT           NULL,
    [CreateDate] SMALLDATETIME NULL,
    [Call_In]    INT           NULL,
    [Call_Out]   INT           NULL,
    CONSTRAINT [PK_CallCenter_Record_Sum] PRIMARY KEY CLUSTERED ([id] ASC)
);


GO
CREATE NONCLUSTERED INDEX [IX_CallCenter_Record_Sum_CreateDate]
    ON [dbo].[CallCenter_Record_Sum]([CreateDate] ASC);


GO
CREATE NONCLUSTERED INDEX [IX_CallCenter_Record_Sum_DeptId]
    ON [dbo].[CallCenter_Record_Sum]([DeptId] ASC);


GO
CREATE NONCLUSTERED INDEX [IX_CallCenter_Record_Sum_CompanyId]
    ON [dbo].[CallCenter_Record_Sum]([CompanyId] ASC);

